<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-weight:400; font-style:normal; "  bgcolor="#ffffff">
Version:0.9
StartHTML:0000000179
EndHTML:0000094101
StartFragment:0000000215
EndFragment:0000094065
SourceURL:https://vremya-ne-zhdet.ru/vba-excel/funktsiya-join-parametry/
<html>
<body>
<!--StartFragment--><div class="entry-header" style="box-sizing: border-box; text-align: var(--textalign,center); --textalign: left; margin-top: 60px; margin-bottom: var(--spacing,60px); color: rgb(39, 38, 38); font-family: Arial, Helvetica, sans-serif, Arial, Helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><div class="nv-title-meta-wrap" style="box-sizing: border-box;"><h1 class="title entry-title" style="box-sizing: border-box; margin: 0px 0px 10px; padding: 0px; font-size: var(--fontsize,var(--h1fontsize)); font-weight: var(--fontweight,var(--h1fontweight)); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--lineheight,var(--h1lineheight)); letter-spacing: var(--letterspacing,var(--h1letterspacing)); text-transform: var(--texttransform,var(--h1texttransform)); overflow-wrap: break-word;">VBA Excel. Функция Join (синтаксис, параметры, значения)</h1><ul class="nv-meta-list" style="box-sizing: border-box; margin: 0px 0px 20px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: var(--liststyle,none); font-size: 0.9em; --avatarsize: 20px;"></ul></div></div><div class="nv-content-wrap entry-content" style="box-sizing: border-box; counter-reset: footnotes 0; --listpad: 20px; --liststyle: disc; --img-m: 24px; margin-bottom: var(--spacing,60px); color: rgb(39, 38, 38); font-family: Arial, Helvetica, sans-serif, Arial, Helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><em style="box-sizing: border-box;">Использование функции Join в VBA Excel, ее синтаксис и параметры. Значения, возвращаемые функцией Join. Примеры использования.</em><span id="more-1324" style="box-sizing: border-box;"></span></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Функция Join предназначена в VBA Excel для объединения подстрок, содержащихся в линейном<span> </span><a href="https://vremya-ne-zhdet.ru/vba-excel/massivy/" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);">массиве</a>, в одну строку с добавлением разделителей. Разделителем может быть как отдельный символ или строка из нескольких символов, так и пустая строка. Функция Join по своему действию является обратной функции<span> </span><a href="https://vremya-ne-zhdet.ru/vba-excel/funktsiya-split-parametry/" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);">Split</a>, которая создает массив подстрок из одной строки.</p><div class="lwptoc lwptoc-autoWidth lwptoc-baseItems lwptoc-light lwptoc-notInherit" data-smooth-scroll="1" data-smooth-scroll-offset="24" data-lwptoc-initialized="1" style="box-sizing: border-box; margin: 32px 0px;"><div class="lwptoc_i" style="box-sizing: border-box; padding: 14px 18px 18px; text-align: left; display: inline-block; color: rgb(51, 51, 51); background: rgb(250, 250, 250);"><div class="lwptoc_header" style="box-sizing: border-box; margin-bottom: 6px;"><b class="lwptoc_title" style="box-sizing: border-box; font-weight: 600;">Содержание</b></div><div class="lwptoc_items lwptoc_items-visible" style="box-sizing: border-box; font-size: 14.4px;"><div class="lwptoc_itemWrap" style="box-sizing: border-box;"><div class="lwptoc_item" style="box-sizing: border-box; margin-top: 0px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/funktsiya-join-parametry/#Sintaksis_funkcii_Join" style="box-sizing: border-box; --linkdeco: underline; color: rgb(49, 117, 228); cursor: pointer; text-decoration: none !important; box-shadow: none !important; border: none !important;"><span class="lwptoc_item_number" style="box-sizing: border-box; margin-right: 2px;">1.</span><span> </span><span class="lwptoc_item_label" style="box-sizing: border-box;">Синтаксис функции Join</span></a></div><div class="lwptoc_item" style="box-sizing: border-box; margin-top: 2px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/funktsiya-join-parametry/#Parametry_funkcii_Join" style="box-sizing: border-box; --linkdeco: underline; color: rgb(49, 117, 228); cursor: pointer; text-decoration: none !important; box-shadow: none !important; border: none !important;"><span class="lwptoc_item_number" style="box-sizing: border-box; margin-right: 2px;">2.</span><span> </span><span class="lwptoc_item_label" style="box-sizing: border-box;">Параметры функции Join</span></a></div><div class="lwptoc_item" style="box-sizing: border-box; margin-top: 2px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/funktsiya-join-parametry/#Vozvrasaemye_znacenia" style="box-sizing: border-box; --linkdeco: underline; color: rgb(49, 117, 228); cursor: pointer; text-decoration: none !important; box-shadow: none !important; border: none !important;"><span class="lwptoc_item_number" style="box-sizing: border-box; margin-right: 2px;">3.</span><span> </span><span class="lwptoc_item_label" style="box-sizing: border-box;">Возвращаемые значения</span></a></div></div></div></div></div><h2 style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; font-size: var(--h2fontsize); font-weight: var(--h2fontweight); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--h2lineheight); letter-spacing: var(--h2letterspacing); text-transform: var(--h2texttransform);"><span id="Sintaksis_funkcii_Join" style="box-sizing: border-box;">Синтаксис функции Join</span></h2><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><code style="box-sizing: border-box; background: rgb(208, 239, 251); border-radius: 5px; border: 1px solid var(--nv-light-bg); padding: 0px 3px; color: rgb(51, 51, 51);">Join (SourceArray,[Delimiter])</code></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Обязательным параметром функции Join является SourceArray, если Delimiter явно не указан, используется его значение по-умолчанию.</p><h2 style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; font-size: var(--h2fontsize); font-weight: var(--h2fontweight); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--h2lineheight); letter-spacing: var(--h2letterspacing); text-transform: var(--h2texttransform);"><span id="Parametry_funkcii_Join" style="box-sizing: border-box;">Параметры функции Join</span></h2><table width="100%" style="box-sizing: border-box; border-collapse: separate; border-spacing: 0px; border-width: 1px 0px 0px 1px; margin: 0px 0px 20px; width: 960px; word-break: initial;"><tbody style="box-sizing: border-box;"><tr style="box-sizing: border-box;"><td width="20%" style="box-sizing: border-box; padding: 20px; text-align: center; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);"><b style="box-sizing: border-box;">Параметр</b></td><td width="60%" style="box-sizing: border-box; padding: 20px; text-align: center; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);"><strong style="box-sizing: border-box;">Описание</strong></td><td width="20%" style="box-sizing: border-box; padding: 20px; text-align: center; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);"><strong style="box-sizing: border-box;">Значение</strong><br style="box-sizing: border-box;"><strong style="box-sizing: border-box;">по умолчанию</strong></td></tr><tr style="box-sizing: border-box;"><td style="box-sizing: border-box; padding: 20px; text-align: left; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);"><strong style="box-sizing: border-box;">SourceArray</strong></td><td style="box-sizing: border-box; padding: 20px; text-align: left; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);">Одномерный массив, содержащий объединяемые подстроки</td><td style="box-sizing: border-box; padding: 20px; text-align: left; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);">Нет</td></tr><tr style="box-sizing: border-box;"><td style="box-sizing: border-box; padding: 20px; text-align: left; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);"><strong style="box-sizing: border-box;">Delimiter</strong></td><td style="box-sizing: border-box; padding: 20px; text-align: left; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);">Разделитель, представляющий пустую строку*, один или более символов</td><td style="box-sizing: border-box; padding: 20px; text-align: left; font-size: 0.9em; border: 1px solid rgb(47, 79, 79); background: rgb(255, 247, 236);">Пробел</td></tr></tbody></table><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">*Если в качестве разделителя используется пустая строка, то все элементы списка объединяются без разделителей — слитно.</p><h2 style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; font-size: var(--h2fontsize); font-weight: var(--h2fontweight); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--h2lineheight); letter-spacing: var(--h2letterspacing); text-transform: var(--h2texttransform);"><span id="Vozvrasaemye_znacenia" style="box-sizing: border-box;">Возвращаемые значения</span></h2><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Функция Join возвращает строку, полученную путем объединения исходных подстрок, содержащихся в одномерном массиве, с добавлением между соединяемыми подстроками разделителей, состоящих из одного или более символов.</p><hr style="box-sizing: border-box; margin: 10px 0px 20px; padding: 0px; color: inherit; height: 0px; border-width: 2px 0px 0px; border-right-style: initial; border-bottom-style: initial; border-left-style: initial; border-color: initial; border-image: initial; border-top-style: solid; display: inline-block; width: 960px;"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><strong style="box-sizing: border-box;">Пример 1</strong></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><div id="urvanov-syntax-highlighter-65073fced12d9586862960" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 960px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 958px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">7</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12d9586862960-8" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">8</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 940.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Test1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">String</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">s</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">String</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">0</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Иван"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"да"</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"марья"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">s</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Join</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"-"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">MsgBox</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">s</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12d9586862960-8" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Результат в MsgBox:<span> </span><strong style="box-sizing: border-box;">Иван-да-марья</strong></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">В первом примере используется <strong style="box-sizing: border-box;">Delimiter</strong><span> </span>= «-» (дефис).</p><hr style="box-sizing: border-box; margin: 10px 0px 20px; padding: 0px; color: inherit; height: 0px; border-width: 2px 0px 0px; border-right-style: initial; border-bottom-style: initial; border-left-style: initial; border-color: initial; border-image: initial; border-top-style: solid; display: inline-block; width: 960px;"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><strong style="box-sizing: border-box;">Пример 2</strong></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><div id="urvanov-syntax-highlighter-65073fced12ea691149925" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 960px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 958px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">7</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ea691149925-8" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">8</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 940.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Test2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">String</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">s</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">String</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">0</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Кро"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"ко"</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"дил"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">s</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Join</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">""</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">MsgBox</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">s</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ea691149925-8" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Результат в MsgBox:<span> </span><strong style="box-sizing: border-box;">Крокодил</strong></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Во втором примере используется <strong style="box-sizing: border-box;">Delimiter</strong><span> </span>= «» (пустая строка).</p><hr style="box-sizing: border-box; margin: 10px 0px 20px; padding: 0px; color: inherit; height: 0px; border-width: 2px 0px 0px; border-right-style: initial; border-bottom-style: initial; border-left-style: initial; border-color: initial; border-image: initial; border-top-style: solid; display: inline-block; width: 960px;"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><strong style="box-sizing: border-box;">Пример 3</strong></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><div id="urvanov-syntax-highlighter-65073fced12ee283696114" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 960px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 958px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">7</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-8" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">8</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-9" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">9</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073fced12ee283696114-10" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">10</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 932.734px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Test3</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">4</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Variant</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">s</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">String</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">0</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Бегемот"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">255</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Жираф"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">3</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">788</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">4</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Зайчик"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-8" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">s</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Join</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">a</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-9" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">MsgBox</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">s</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073fced12ee283696114-10" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Результат в MsgBox:<span> </span><strong style="box-sizing: border-box;">Бегемот 255 Жираф 788 Зайчик</strong></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Третий пример показывает, что функция Join работает не только с массивами строкового типа (As String), но и универсального типа (As Variant). Числовые значения автоматически преобразуются в текстовые и объединяются в общую строку. В третьем примере используется <strong style="box-sizing: border-box;">Delimiter</strong> по-умолчанию.</p><hr style="box-sizing: border-box; margin: 10px 0px 20px; padding: 0px; color: inherit; height: 0px; border-width: 2px 0px 0px; border-right-style: initial; border-bottom-style: initial; border-left-style: initial; border-color: initial; border-image: initial; border-top-style: solid; display: inline-block; width: 960px;"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Вы можете скопировать коды из приведенных примеров в модуль VBA своей рабочей книги Excel, посмотреть, как они работают. Поэкспериментируйте, подставляя свои данные, чтобы на практике ознакомиться с возможностями функции Join.</p><div class="blok-fon-3" style="box-sizing: border-box; width: auto; height: auto; padding: 0.4375rem; margin: 0px 0px 1.5rem; background-color: rgb(230, 230, 250);"><a href="https://vremya-ne-zhdet.ru/vba-excel/soderzhaniye-rubriki/" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);">Содержание рубрики VBA Excel</a><span> </span>по тематическим разделам со ссылками на все статьи.</div></div><br class="Apple-interchange-newline"><!--EndFragment-->
</body>
</html></body></html>